INSERT INTO [dbo].[PatientActivation] ([TransactionId], [PatientCode], [LastName], [FirstName], [DateOfBirth], [Phone], [Sex], [MemberType], [MembershipSOSNumber], [MembershipSOSExpDate], [InsuranceCardNumber], [InsuranceCardExpDate], [CompanyCode], [CompanyName], [Nationality], [ApptRemark], [ApptStatus], [ApptNote], [Remark], [Status], [IsComplete], [CreateUser], [CreateDate]) VALUES (N'30MAY13HCM1-001', N'HCM01B00002', N'Bloggs', N'Joe', '1970-12-25 00:00:00.000', NULL, 'M', N'Visitor', NULL, NULL, NULL, NULL, NULL, NULL, N'Canadian', NULL, N'Not have appointment', N'', NULL, N'Open', 0, N'vy.le', '2013-05-30 16:02:53.923')
